Release 10.1A: OpenEdge Development:
ADM Reference

Column properties for query objects

There are a number of column properties available for which you can obtain and set (write) field values. All of these properties can be read and some of them can be set. To read and set column properties, you use the following prefixes with the specific column property:

Column — Use to read the value of a specific column property. For example, if you want to read the value of the ColumnLabel property, you would specify ColumnColumnLabel. This would return the label of the column you specify. To obtain the data type for a specific column property, you would specify ColumnDataType. This would return the data type of the specified column.
Assign — Use to set the value of a specific column property. For example, if you want to set the label value for a specific column, you specify assignColumnColumnLabel. This would set the label value for the column you specify. To set a value for the column format, you would specify assignColumnFormat.

For additional information, see OpenEdge Development: Progress Dynamics Basic Development and OpenEdge Development: Progress Dynamics Advanced Development .

Table 5–1 lists the column properties for query objects, provides a brief description of each property, indicates whether the property can be read or set (write), and lists the data type for each property.

Table 5–1: Column properties for query objects

Column property	Description	Read	Write	Data type
ColumnLabel	Label of the specified column.	Yes	Yes	CHARACTER
DataType	Data type of the specified column.	Yes	No	CHARACTER
DbColumn	Qualified database name (DatabaseName.TableName. FieldName) mapped to the RowObject column identified by pcColumn.	Yes	No	CHARACTER
Extent	Extent of the specified RowObject column.	Yes	No	INTEGER
Format	Format of the specified RowObject column.	Yes	Yes	CHARACTER
Handle	Handle of the specified RowObject column.	Yes	No	HANDLE
Help	Help text for the specified RowObject column.	Yes	Yes	CHARACTER
Initial	Initial value for a specified field as a character string with the field FORMAT applied.	Yes	No	CHARACTER
Label	Label for the specified column.	Yes	No	CHARACTER
Modified	Indicates whether or not a specified RowObject field has been modified. TRUE if modified, FALSE if not modified.	Yes	No	LOGICAL
PrivateData	Private Data property of the specified column.	Yes	Yes	CHARACTER
QuerySelection	CHR(1)-separated string with all operators and values, but no field names, that have been added to the Query for this column.	Yes	No	CHARACTER
ReadOnly	Identifies whether or not the specified column is in the list of columns that you can update. TRUE, if the column is in the list and FALSE, if not in the list.	Yes	No	LOGICAL
StringValue	String Value of the specified column in the SmartDataObject RowObject buffer.	Yes	No	CHARACTER
Table	Database table name of the specified column.	Yes	No	CHARACTER
ValExp	Validation expression for the specified column in a RowObject temp-table.	Yes	Yes	CHARACTER
ValMsg	Validation message text for the specified column of the SmartDataObjects RowObject temp-table.	Yes	Yes	CHARACTER
Value	Raw (unformatted) character value of the specified field in a RowObject temp-table.	Yes	No	CHARACTER
Width	Width in character units of the specified column of the SmartDataObjects RowObject temp-table.	Yes	No	DECIMAL